﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace JVP.Infrastructure
{
    public interface IOfficeManager
    {
        bool isValidUser(string userName, string passWord, SqlCommand cmd);
        SqlDataReader getPlans(SqlCommand cmd);
        SqlDataReader getAllPlans(SqlCommand cmd);
        SqlDataReader getPlan(string planID, SqlCommand cmd);        
        bool addPlan(string planName, string planTerm, string planType, string planStatus, string description, SqlCommand cmd);
        bool editPlan(string planID, string planName, string planTerm, string planType, string planStatus, string description, SqlCommand cmd);
        bool addScheme(int schemeDues, string planYear, string amtInstall, string amtConsi, string amtExpConsi, string amtAccConsi, string plotSize, string schemeStatus, string planID, SqlCommand cmd);
        bool editScheme(string schemeID, int schemeDues, string planYear, string amtInstall, string amtConsi, string amtExpConsi, string amtAccConsi, string plotSize, string schemeStatus, string planID, SqlCommand cmd);
        SqlDataAdapter getSchemes(SqlCommand cmd);
        SqlDataReader getScheme(string planID, SqlCommand cmd);
        SqlDataReader getBranches(SqlCommand cmd);
        SqlDataReader getBranch(string branchID, SqlCommand cmd);
        bool addBranch(string branchCode, string branchName, string branchCity, string branchCCode, SqlCommand cmd);
        bool createAccount(string fName, string lName, DateTime dob, string empAddress, string empMobile, string empStatus, int branchID, SqlCommand cmd);
        bool changePassword(string userName, string oldPass, string newPass, SqlCommand cmd);
        bool addDesignation(string designName, int rank, decimal firstYear, decimal secondYear, decimal thirdYear, decimal lumpSum, SqlCommand cmd);
        bool editDesignation(int designID, string designName, int rank, decimal firstYear, decimal secondYear, decimal thirdYear, decimal lumpSum, SqlCommand cmd);
        SqlDataAdapter getDesignations(SqlCommand cmd);
        SqlDataAdapter getDownLine(SqlCommand cmd);
        SqlDataAdapter getInformations(string designID, SqlCommand cmd);
        SqlDataAdapter getCustomers(string designID, SqlCommand cmd);
        SqlDataReader getUpline(string designID, SqlCommand cmd);
        SqlDataReader getOfficeStaffDetails(string userID, SqlCommand cmd);
    }
}
